Unix Technical Forum

jdbc with a UDF

This is a discussion on jdbc with a UDF within the MySQL General forum forums, part of the MySQL category; --> I'm getting what appears to be a java reference back from values I return from a UDF. The values ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 06:33 AM
Dave G
 
Posts: n/a
Default jdbc with a UDF

I'm getting what appears to be a java reference back from values I return
from a UDF. The values appear find using php, and in the mysql client.
The result looks something like:

B@1e19999

The result should be a string (some representing floats, others as integers).

Any help will be appreciated. I searched on google and only found where
another person had the same problem, but no solution.

Dave G.



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 06:33 AM
Dave G
 
Posts: n/a
Default Re: jdbc with a UDF

Thanks for the reply. I tracked the problem down. Simple problem really,
I was using an old mysql-connector-java jar. I updated that to the
correct version for my database and it all worked.

What version of of the JDBC driver are you using?
Good question to ask. I asked myself that very question shortly after
emailing the list.

Thanks

David Godsey

> Perhaps you could show us the Java code you are using to invoke this
> UDF? What are you expecting to get back form it? a result set? a
> return code from a function? What version of of the JDBC driver are
> you using?
>
> - michael
>
>
> On 6/5/07, Dave G <mysql@godseyfamily.com> wrote:
>> I'm getting what appears to be a java reference back from values I
>> return
>> from a UDF. The values appear find using php, and in the mysql client.
>> The result looks something like:
>>
>> B@1e19999
>>
>> The result should be a string (some representing floats, others as
>> integers).
>>
>> Any help will be appreciated. I searched on google and only found where
>> another person had the same problem, but no solution.
>>
>> Dave G.
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=mdykman@gmail.com
>>
>>

>
>
> --
> - michael dykman
> - mdykman@gmail.com
>
> - All models are wrong. Some models are useful.
>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:24 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com