You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Todd Grigsby <st...@tgrigsby.com> on 2009/12/13 22:23:03 UTC
MySQL + JDBC
Let me simplify the question: Has anyone out there managed to create a
working connection to the latest version of MySQL 64-bit via JDBC from
Struts 2?
TG
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Todd Grigsby <st...@tgrigsby.com>.
Works great, Neil, thanks for asking.
TG
Neil Aggarwal wrote:
>> Oh, and a relevant follow-up question: do you use JDBC-ODBC
>> to connect
>> to MySQL?
>>
>
> I never used ODBC to talk to MySQL. I am not sure how well
> that would work.
>
> Thanks,
> Neil
>
> --
> Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
> Host your MySQL database on a CentOS virtual server for $25/mo
> Unmetered bandwidth = no overage charges, 7 day free trial
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
>
RE: MySQL + JDBC
Posted by Neil Aggarwal <ne...@JAMMConsulting.com>.
> Oh, and a relevant follow-up question: do you use JDBC-ODBC
> to connect
> to MySQL?
I never used ODBC to talk to MySQL. I am not sure how well
that would work.
Thanks,
Neil
--
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
Host your MySQL database on a CentOS virtual server for $25/mo
Unmetered bandwidth = no overage charges, 7 day free trial
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Todd Grigsby <st...@tgrigsby.com>.
Oh, and a relevant follow-up question: do you use JDBC-ODBC to connect
to MySQL?
TG
Neil Aggarwal wrote:
>> Let me simplify the question: Has anyone out there managed to
>> create a
>> working connection to the latest version of MySQL 64-bit via
>> JDBC from
>> Struts 2?
>>
>
> I am sure many people have. I run 64 bit servers with MySQL
> and Struts 2.
>
> What are you seeing?
>
> Neil
>
> --
> Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
> Host your Struts app on a CentOS VPS for only $25/month!
> Unmetered bandwidth = no overage charges, 7 day free trial
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
>
Re: MySQL + JDBC
Posted by Todd Grigsby <st...@tgrigsby.com>.
Yes. Running Tomcat 6 as a Windows service... Ok, this is
interesting. On a whim, I ran tomcat6w, and when it came up, it appears
to using the "C:\Program Files (x86)\Java\jre6\bin\client\jvm.dll",
which implies to me that the JVM it's attempting to use is the 32-bit
version.
High five, Mr. Kobly.
I searched around and, under C:\Program Files, I found a couple of
jvm.dll's. I tried pointing Tomcat to each of them, but the service
died with an error code of #1. Not sure what that is, but it occurs to
me that I might fix this by simply reinstalling Tomcat and, when it asks
for a JRE, I'll point it to the other JVM DLLs and see what it does.
TG
Patrick J Kobly wrote:
> Running the binary dist of Tomcat?
>
> tomcat.exe / tomcatw.exe
>
> PK
>
> Todd Grigsby wrote:
>>
>>
>> Patrick J Kobly wrote:
>>> Todd Grigsby wrote:
>>>> Other native apps. The Java apps are being migrated from a 32-bit
>>>> environment (WinXP and Java 32-bit + Struts 1.1), and they worked
>>>> there. I don't want to point to any one thing, since every part of
>>>> the equation is a newer version of what was there before, but at
>>>> this point the only things that can't use the connections are the
>>>> web apps.
>>> But the web apps are the only things that use Java. You don't have
>>> standalone Java apps or Java webapps built on a different framework
>>> than Struts... The issue is almost certainly a 32-bit JRE trying to
>>> access a 64-bit ODBC driver.
>>
>> I'll buy that, but I'm confused -- I installed 64-bit Java, and when
>> I open a command prompt and do "java -version", it identifies itself as:
>>
>> Java(TM) SE Runtime Environment (build 1.6.0_16-b01)
>> Java HotSpot(TM) 64-Bit Server VM (build 14.2-b01, mixed mode)
>>
>> But I'll see if I have anything on my system that is getting loaded
>> that's 32-bit.
>>
>> Thanks!
>>
>> TG
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>> For additional commands, e-mail: user-help@struts.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Patrick J Kobly <pa...@kobly.com>.
Running the binary dist of Tomcat?
tomcat.exe / tomcatw.exe
PK
Todd Grigsby wrote:
>
>
> Patrick J Kobly wrote:
>> Todd Grigsby wrote:
>>> Other native apps. The Java apps are being migrated from a 32-bit
>>> environment (WinXP and Java 32-bit + Struts 1.1), and they worked
>>> there. I don't want to point to any one thing, since every part of
>>> the equation is a newer version of what was there before, but at
>>> this point the only things that can't use the connections are the
>>> web apps.
>> But the web apps are the only things that use Java. You don't have
>> standalone Java apps or Java webapps built on a different framework
>> than Struts... The issue is almost certainly a 32-bit JRE trying to
>> access a 64-bit ODBC driver.
>
> I'll buy that, but I'm confused -- I installed 64-bit Java, and when I
> open a command prompt and do "java -version", it identifies itself as:
>
> Java(TM) SE Runtime Environment (build 1.6.0_16-b01)
> Java HotSpot(TM) 64-Bit Server VM (build 14.2-b01, mixed mode)
>
> But I'll see if I have anything on my system that is getting loaded
> that's 32-bit.
>
> Thanks!
>
> TG
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Todd Grigsby <st...@tgrigsby.com>.
Patrick J Kobly wrote:
> Todd Grigsby wrote:
>> Other native apps. The Java apps are being migrated from a 32-bit
>> environment (WinXP and Java 32-bit + Struts 1.1), and they worked
>> there. I don't want to point to any one thing, since every part of
>> the equation is a newer version of what was there before, but at this
>> point the only things that can't use the connections are the web apps.
> But the web apps are the only things that use Java. You don't have
> standalone Java apps or Java webapps built on a different framework
> than Struts... The issue is almost certainly a 32-bit JRE trying to
> access a 64-bit ODBC driver.
I'll buy that, but I'm confused -- I installed 64-bit Java, and when I
open a command prompt and do "java -version", it identifies itself as:
Java(TM) SE Runtime Environment (build 1.6.0_16-b01)
Java HotSpot(TM) 64-Bit Server VM (build 14.2-b01, mixed mode)
But I'll see if I have anything on my system that is getting loaded
that's 32-bit.
Thanks!
TG
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Patrick J Kobly <pa...@kobly.com>.
Todd Grigsby wrote:
> Other native apps. The Java apps are being migrated from a 32-bit
> environment (WinXP and Java 32-bit + Struts 1.1), and they worked
> there. I don't want to point to any one thing, since every part of
> the equation is a newer version of what was there before, but at this
> point the only things that can't use the connections are the web apps.
But the web apps are the only things that use Java. You don't have
standalone Java apps or Java webapps built on a different framework than
Struts... The issue is almost certainly a 32-bit JRE trying to access a
64-bit ODBC driver.
> Have you tried an all 64-bit setup with ODBC?
Nope. Have never had a need for ODBC. Though I can sorta see its
advantages in a mixed-language environment.
> TG
PK
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Todd Grigsby <st...@tgrigsby.com>.
Other native apps. The Java apps are being migrated from a 32-bit
environment (WinXP and Java 32-bit + Struts 1.1), and they worked
there. I don't want to point to any one thing, since every part of the
equation is a newer version of what was there before, but at this point
the only things that can't use the connections are the web apps. Have
you tried an all 64-bit setup with ODBC?
TG
Patrick J Kobly wrote:
> Do you have other Java apps working, or just other native apps?
>
> PK
>
> Todd Grigsby wrote:
>>
>>
>> It's all 64-bit, installed correctly enough to work from other apps.
>> I will try the Sun forums.
>>
>> TG
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Patrick J Kobly <pa...@kobly.com>.
Do you have other Java apps working, or just other native apps?
PK
Todd Grigsby wrote:
>
>
> It's all 64-bit, installed correctly enough to work from other apps.
> I will try the Sun forums.
>
> TG
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Todd Grigsby <st...@tgrigsby.com>.
It's all 64-bit, installed correctly enough to work from other apps. I
will try the Sun forums.
TG
Gabriel Belingueres wrote:
> I don't think it is directly related to Struts.
>
> >From what I googled, seems more like a 32-bit/64-bit component
> mismatch than a Struts issue.
>
> On what JDK/JRE version are you running your app server? it is a 32
> bit version of java? or a 64 bits version?
>
> Your odbc driver is 32 bits or 64 bits? are you sure you installed it correctly?
>
> I particularly don't know how the JDBC-ODBC bridge driver hooks on win
> 64 bits, but I would guess that it depends on the java vm version you
> have installed...may be you can ask in a Sun support forum.
>
> HTH
> Gabriel
>
> 2009/12/15 Todd Grigsby <st...@tgrigsby.com>:
>
>> Yes, thank you Nils-H, I have been digging around in there as well.
>> Unfortunately, the problem only occurs from my Struts apps, and judging
>> from the MySQL forums, not many other people experience this issue.
>>
>> TG
>>
>>
>> Nils-Helge Garli Hegvik wrote:
>>
>>> Have you tried asking over at the MySQL forum? I don't think this is
>>> related to Struts 2.
>>>
>>> Nils-H
>>>
>>> On Tue, Dec 15, 2009 at 8:26 AM, Todd Grigsby <st...@tgrigsby.com>
>>> wrote:
>>>
>>>
>>>> (Beating head on keyboard...)
>>>> "So one more time for the folks at home: Is there anyone out there who
>>>> has
>>>> managed to get MySQL 64-bit to work via ODBC?"
>>>>
>>>> For those who aren't aware, MySQL has an ODBC connector called, oddly
>>>> enough, Connector/ODBC. In previous versions it was called MyODBC. It
>>>> does
>>>> work, as evidenced by the fact that I can connect from Windows apps with
>>>> ease. What doesn't work, and the only thing I'm looking for an answer to
>>>> is,
>>>> why do I get the error, "The specified DSN contains an architecture
>>>> mismatch
>>>> between the Driver and Application" when connecting from within Struts 2?
>>>> But at this point I'd be happy hearing from anyone that has gotten
>>>> "MySQL
>>>> 64-bit to work via ODBC."
>>>>
>>>> TG
>>>>
>>>> Lee Clemens wrote:
>>>>
>>>>
>>>>> Not to sound like a jerk, but have you gotten JDBC (MySQL Connector/J)
>>>>> working with a MySQL 64-bit server? Or is this specifically a Struts
>>>>> issue?
>>>>> If so, what message/condition do you receive?
>>>>>
>>>>> Or are you merely asking if MySQL 64-bit is compatible with ODBC [OT]?
>>>>>
>>>>>
>>>>> -----Original Message-----
>>>>> From: Todd Grigsby [mailto:strutsuser@tgrigsby.com] Sent: Monday,
>>>>> December
>>>>> 14, 2009 9:57 PM
>>>>> To: Struts Users Mailing List
>>>>> Subject: Re: MySQL + JDBC
>>>>>
>>>>>
>>>>>
>>>>> Not that I wanted to get into a debate about the usefulness of ODBC, but
>>>>> the Java-based web services we have aren't the only things that connect
>>>>> to
>>>>> these databases, and going through ODBC has been, for the last 10 years,
>>>>> a
>>>>> very nice and consistent way to connect across all our applications and
>>>>> utilities. We have, at one time or another, supported all of the
>>>>> following:
>>>>>
>>>>> MySQL
>>>>> Oracle
>>>>> SQL Server
>>>>> Informix
>>>>> DB2
>>>>> mSQL
>>>>> Pervasive SQL
>>>>> MS Access (pre-Jet)
>>>>>
>>>>> And a few others, and we have connected to these databases via ODBC all
>>>>> along the way. Keeping the connection mechanism consistent has made
>>>>> development work in a number of languages simple. So while I certainly
>>>>> appreciate everyone's enthusiasm for talking directly to MySQL, I have a
>>>>> legacy code base that works *REALLY* well through ODBC, and I'd like to
>>>>> stick with it.
>>>>>
>>>>> So one more time for the folks at home: Is there anyone out there who
>>>>> has
>>>>> managed to get MySQL 64-bit to work via ODBC?
>>>>>
>>>>> TG
>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>
>>>>
>>>>
>>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>> For additional commands, e-mail: user-help@struts.apache.org
>>>
>>>
>>>
>>>
>>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
>
Re: MySQL + JDBC
Posted by Gabriel Belingueres <be...@gmail.com>.
I don't think it is directly related to Struts.
>From what I googled, seems more like a 32-bit/64-bit component
mismatch than a Struts issue.
On what JDK/JRE version are you running your app server? it is a 32
bit version of java? or a 64 bits version?
Your odbc driver is 32 bits or 64 bits? are you sure you installed it correctly?
I particularly don't know how the JDBC-ODBC bridge driver hooks on win
64 bits, but I would guess that it depends on the java vm version you
have installed...may be you can ask in a Sun support forum.
HTH
Gabriel
2009/12/15 Todd Grigsby <st...@tgrigsby.com>:
>
> Yes, thank you Nils-H, I have been digging around in there as well.
> Unfortunately, the problem only occurs from my Struts apps, and judging
> from the MySQL forums, not many other people experience this issue.
>
> TG
>
>
> Nils-Helge Garli Hegvik wrote:
>>
>> Have you tried asking over at the MySQL forum? I don't think this is
>> related to Struts 2.
>>
>> Nils-H
>>
>> On Tue, Dec 15, 2009 at 8:26 AM, Todd Grigsby <st...@tgrigsby.com>
>> wrote:
>>
>>>
>>> (Beating head on keyboard...)
>>> "So one more time for the folks at home: Is there anyone out there who
>>> has
>>> managed to get MySQL 64-bit to work via ODBC?"
>>>
>>> For those who aren't aware, MySQL has an ODBC connector called, oddly
>>> enough, Connector/ODBC. In previous versions it was called MyODBC. It
>>> does
>>> work, as evidenced by the fact that I can connect from Windows apps with
>>> ease. What doesn't work, and the only thing I'm looking for an answer to
>>> is,
>>> why do I get the error, "The specified DSN contains an architecture
>>> mismatch
>>> between the Driver and Application" when connecting from within Struts 2?
>>> But at this point I'd be happy hearing from anyone that has gotten
>>> "MySQL
>>> 64-bit to work via ODBC."
>>>
>>> TG
>>>
>>> Lee Clemens wrote:
>>>
>>>>
>>>> Not to sound like a jerk, but have you gotten JDBC (MySQL Connector/J)
>>>> working with a MySQL 64-bit server? Or is this specifically a Struts
>>>> issue?
>>>> If so, what message/condition do you receive?
>>>>
>>>> Or are you merely asking if MySQL 64-bit is compatible with ODBC [OT]?
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: Todd Grigsby [mailto:strutsuser@tgrigsby.com] Sent: Monday,
>>>> December
>>>> 14, 2009 9:57 PM
>>>> To: Struts Users Mailing List
>>>> Subject: Re: MySQL + JDBC
>>>>
>>>>
>>>>
>>>> Not that I wanted to get into a debate about the usefulness of ODBC, but
>>>> the Java-based web services we have aren't the only things that connect
>>>> to
>>>> these databases, and going through ODBC has been, for the last 10 years,
>>>> a
>>>> very nice and consistent way to connect across all our applications and
>>>> utilities. We have, at one time or another, supported all of the
>>>> following:
>>>>
>>>> MySQL
>>>> Oracle
>>>> SQL Server
>>>> Informix
>>>> DB2
>>>> mSQL
>>>> Pervasive SQL
>>>> MS Access (pre-Jet)
>>>>
>>>> And a few others, and we have connected to these databases via ODBC all
>>>> along the way. Keeping the connection mechanism consistent has made
>>>> development work in a number of languages simple. So while I certainly
>>>> appreciate everyone's enthusiasm for talking directly to MySQL, I have a
>>>> legacy code base that works *REALLY* well through ODBC, and I'd like to
>>>> stick with it.
>>>>
>>>> So one more time for the folks at home: Is there anyone out there who
>>>> has
>>>> managed to get MySQL 64-bit to work via ODBC?
>>>>
>>>> TG
>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>
>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>> For additional commands, e-mail: user-help@struts.apache.org
>>>
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>> For additional commands, e-mail: user-help@struts.apache.org
>>
>>
>>
>>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Todd Grigsby <st...@tgrigsby.com>.
Yes, thank you Nils-H, I have been digging around in there as well.
Unfortunately, the problem only occurs from my Struts apps, and judging
from the MySQL forums, not many other people experience this issue.
TG
Nils-Helge Garli Hegvik wrote:
> Have you tried asking over at the MySQL forum? I don't think this is
> related to Struts 2.
>
> Nils-H
>
> On Tue, Dec 15, 2009 at 8:26 AM, Todd Grigsby <st...@tgrigsby.com> wrote:
>
>> (Beating head on keyboard...)
>> "So one more time for the folks at home: Is there anyone out there who has
>> managed to get MySQL 64-bit to work via ODBC?"
>>
>> For those who aren't aware, MySQL has an ODBC connector called, oddly
>> enough, Connector/ODBC. In previous versions it was called MyODBC. It does
>> work, as evidenced by the fact that I can connect from Windows apps with
>> ease. What doesn't work, and the only thing I'm looking for an answer to is,
>> why do I get the error, "The specified DSN contains an architecture mismatch
>> between the Driver and Application" when connecting from within Struts 2?
>> But at this point I'd be happy hearing from anyone that has gotten "MySQL
>> 64-bit to work via ODBC."
>>
>> TG
>>
>> Lee Clemens wrote:
>>
>>> Not to sound like a jerk, but have you gotten JDBC (MySQL Connector/J)
>>> working with a MySQL 64-bit server? Or is this specifically a Struts
>>> issue?
>>> If so, what message/condition do you receive?
>>>
>>> Or are you merely asking if MySQL 64-bit is compatible with ODBC [OT]?
>>>
>>>
>>> -----Original Message-----
>>> From: Todd Grigsby [mailto:strutsuser@tgrigsby.com] Sent: Monday, December
>>> 14, 2009 9:57 PM
>>> To: Struts Users Mailing List
>>> Subject: Re: MySQL + JDBC
>>>
>>>
>>>
>>> Not that I wanted to get into a debate about the usefulness of ODBC, but
>>> the Java-based web services we have aren't the only things that connect to
>>> these databases, and going through ODBC has been, for the last 10 years, a
>>> very nice and consistent way to connect across all our applications and
>>> utilities. We have, at one time or another, supported all of the following:
>>>
>>> MySQL
>>> Oracle
>>> SQL Server
>>> Informix
>>> DB2
>>> mSQL
>>> Pervasive SQL
>>> MS Access (pre-Jet)
>>>
>>> And a few others, and we have connected to these databases via ODBC all
>>> along the way. Keeping the connection mechanism consistent has made
>>> development work in a number of languages simple. So while I certainly
>>> appreciate everyone's enthusiasm for talking directly to MySQL, I have a
>>> legacy code base that works *REALLY* well through ODBC, and I'd like to
>>> stick with it.
>>>
>>> So one more time for the folks at home: Is there anyone out there who has
>>> managed to get MySQL 64-bit to work via ODBC?
>>>
>>> TG
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>> For additional commands, e-mail: user-help@struts.apache.org
>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>> For additional commands, e-mail: user-help@struts.apache.org
>>>
>>>
>>>
>>>
>>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>> For additional commands, e-mail: user-help@struts.apache.org
>>
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
>
Re: MySQL + JDBC
Posted by Nils-Helge Garli Hegvik <ni...@gmail.com>.
Have you tried asking over at the MySQL forum? I don't think this is
related to Struts 2.
Nils-H
On Tue, Dec 15, 2009 at 8:26 AM, Todd Grigsby <st...@tgrigsby.com> wrote:
>
>
> (Beating head on keyboard...)
> "So one more time for the folks at home: Is there anyone out there who has
> managed to get MySQL 64-bit to work via ODBC?"
>
> For those who aren't aware, MySQL has an ODBC connector called, oddly
> enough, Connector/ODBC. In previous versions it was called MyODBC. It does
> work, as evidenced by the fact that I can connect from Windows apps with
> ease. What doesn't work, and the only thing I'm looking for an answer to is,
> why do I get the error, "The specified DSN contains an architecture mismatch
> between the Driver and Application" when connecting from within Struts 2?
> But at this point I'd be happy hearing from anyone that has gotten "MySQL
> 64-bit to work via ODBC."
>
> TG
>
> Lee Clemens wrote:
>>
>> Not to sound like a jerk, but have you gotten JDBC (MySQL Connector/J)
>> working with a MySQL 64-bit server? Or is this specifically a Struts
>> issue?
>> If so, what message/condition do you receive?
>>
>> Or are you merely asking if MySQL 64-bit is compatible with ODBC [OT]?
>>
>>
>> -----Original Message-----
>> From: Todd Grigsby [mailto:strutsuser@tgrigsby.com] Sent: Monday, December
>> 14, 2009 9:57 PM
>> To: Struts Users Mailing List
>> Subject: Re: MySQL + JDBC
>>
>>
>>
>> Not that I wanted to get into a debate about the usefulness of ODBC, but
>> the Java-based web services we have aren't the only things that connect to
>> these databases, and going through ODBC has been, for the last 10 years, a
>> very nice and consistent way to connect across all our applications and
>> utilities. We have, at one time or another, supported all of the following:
>>
>> MySQL
>> Oracle
>> SQL Server
>> Informix
>> DB2
>> mSQL
>> Pervasive SQL
>> MS Access (pre-Jet)
>>
>> And a few others, and we have connected to these databases via ODBC all
>> along the way. Keeping the connection mechanism consistent has made
>> development work in a number of languages simple. So while I certainly
>> appreciate everyone's enthusiasm for talking directly to MySQL, I have a
>> legacy code base that works *REALLY* well through ODBC, and I'd like to
>> stick with it.
>>
>> So one more time for the folks at home: Is there anyone out there who has
>> managed to get MySQL 64-bit to work via ODBC?
>>
>> TG
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>> For additional commands, e-mail: user-help@struts.apache.org
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>> For additional commands, e-mail: user-help@struts.apache.org
>>
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Todd Grigsby <st...@tgrigsby.com>.
(Beating head on keyboard...)
"So one more time for the folks at home: Is there anyone out there who
has managed to get MySQL 64-bit to work via ODBC?"
For those who aren't aware, MySQL has an ODBC connector called, oddly
enough, Connector/ODBC. In previous versions it was called MyODBC. It
does work, as evidenced by the fact that I can connect from Windows apps
with ease. What doesn't work, and the only thing I'm looking for an
answer to is, why do I get the error, "The specified DSN contains an
architecture mismatch between the Driver and Application" when
connecting from within Struts 2? But at this point I'd be happy hearing
from anyone that has gotten "MySQL 64-bit to work via ODBC."
TG
Lee Clemens wrote:
> Not to sound like a jerk, but have you gotten JDBC (MySQL Connector/J)
> working with a MySQL 64-bit server? Or is this specifically a Struts issue?
> If so, what message/condition do you receive?
>
> Or are you merely asking if MySQL 64-bit is compatible with ODBC [OT]?
>
>
> -----Original Message-----
> From: Todd Grigsby [mailto:strutsuser@tgrigsby.com]
> Sent: Monday, December 14, 2009 9:57 PM
> To: Struts Users Mailing List
> Subject: Re: MySQL + JDBC
>
>
>
> Not that I wanted to get into a debate about the usefulness of ODBC, but
> the Java-based web services we have aren't the only things that connect
> to these databases, and going through ODBC has been, for the last 10
> years, a very nice and consistent way to connect across all our
> applications and utilities. We have, at one time or another, supported
> all of the following:
>
> MySQL
> Oracle
> SQL Server
> Informix
> DB2
> mSQL
> Pervasive SQL
> MS Access (pre-Jet)
>
> And a few others, and we have connected to these databases via ODBC all
> along the way. Keeping the connection mechanism consistent has made
> development work in a number of languages simple. So while I certainly
> appreciate everyone's enthusiasm for talking directly to MySQL, I have a
> legacy code base that works *REALLY* well through ODBC, and I'd like to
> stick with it.
>
> So one more time for the folks at home: Is there anyone out there who
> has managed to get MySQL 64-bit to work via ODBC?
>
> TG
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
RE: MySQL + JDBC
Posted by Lee Clemens <ja...@leeclemens.net>.
Not to sound like a jerk, but have you gotten JDBC (MySQL Connector/J)
working with a MySQL 64-bit server? Or is this specifically a Struts issue?
If so, what message/condition do you receive?
Or are you merely asking if MySQL 64-bit is compatible with ODBC [OT]?
-----Original Message-----
From: Todd Grigsby [mailto:strutsuser@tgrigsby.com]
Sent: Monday, December 14, 2009 9:57 PM
To: Struts Users Mailing List
Subject: Re: MySQL + JDBC
Not that I wanted to get into a debate about the usefulness of ODBC, but
the Java-based web services we have aren't the only things that connect
to these databases, and going through ODBC has been, for the last 10
years, a very nice and consistent way to connect across all our
applications and utilities. We have, at one time or another, supported
all of the following:
MySQL
Oracle
SQL Server
Informix
DB2
mSQL
Pervasive SQL
MS Access (pre-Jet)
And a few others, and we have connected to these databases via ODBC all
along the way. Keeping the connection mechanism consistent has made
development work in a number of languages simple. So while I certainly
appreciate everyone's enthusiasm for talking directly to MySQL, I have a
legacy code base that works *REALLY* well through ODBC, and I'd like to
stick with it.
So one more time for the folks at home: Is there anyone out there who
has managed to get MySQL 64-bit to work via ODBC?
TG
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Todd Grigsby <st...@tgrigsby.com>.
Not that I wanted to get into a debate about the usefulness of ODBC, but
the Java-based web services we have aren't the only things that connect
to these databases, and going through ODBC has been, for the last 10
years, a very nice and consistent way to connect across all our
applications and utilities. We have, at one time or another, supported
all of the following:
MySQL
Oracle
SQL Server
Informix
DB2
mSQL
Pervasive SQL
MS Access (pre-Jet)
And a few others, and we have connected to these databases via ODBC all
along the way. Keeping the connection mechanism consistent has made
development work in a number of languages simple. So while I certainly
appreciate everyone's enthusiasm for talking directly to MySQL, I have a
legacy code base that works *REALLY* well through ODBC, and I'd like to
stick with it.
So one more time for the folks at home: Is there anyone out there who
has managed to get MySQL 64-bit to work via ODBC?
TG
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Gabriel Belingueres <be...@gmail.com>.
What do you mean by "I need to use ODBC to abstract the database connection."??
In most (all?) web containers I know about, there is a standard way of
abstract out the database connection and it is by declaring a
javax.sql.DataSource, which you can get it from JNDI (which is pretty
standard too.)
Declaring the datasource may be app server vendor dependent, but it is
the same mechanism for all database vendors (having a JDBC
drive)...you just declare the fully qualified driver class name, the
username, the password, the connection URL, and the JNDI name.
Also, going to configure an ODBC driver you get the extra complexity
of installing the right version for the OS...I remember a couple of
headaches trying to configure a 32-bit ODBC driver on a 64-bit win2003
server.
Gabriel
2009/12/14 Todd Grigsby <st...@tgrigsby.com>:
> Manos Batsis wrote:
>>
>> Todd Grigsby wrote:
>>>
>>> Fantastic! The error that I'm getting is,
>>> "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
>>> PoolableConnectionFactory ([Microsoft][ODBC Driver Manager] The specified
>>> DSN contains an architecture mismatch between the Driver and Application."
>>> Ever seen that?
>>
>> My guess is you are using a microsoft ODBC to JDBC driver or something?
>> Just use the JDBC drivers for MySQL. You can download those and get docos
>> from MySQL's website.
>
> I would use the MySQL connector directly, but I need to use ODBC to abstract
> the database connection. MySQL is not the only database we connect to. The
> question is, is it possible to go MySQL -> ODBC -> JDBC -> Struts 2? It was
> possible under Struts 1.1 on WinXP, and we are attempting to migrate to
> Struts 2 (or trying to) on Win7 64-bit.
>
> TG
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Todd Grigsby <st...@tgrigsby.com>.
Manos Batsis wrote:
> Todd Grigsby wrote:
>>
>> Fantastic! The error that I'm getting is,
>> "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
>> PoolableConnectionFactory ([Microsoft][ODBC Driver Manager] The
>> specified DSN contains an architecture mismatch between the Driver
>> and Application." Ever seen that?
> My guess is you are using a microsoft ODBC to JDBC driver or
> something? Just use the JDBC drivers for MySQL. You can download those
> and get docos from MySQL's website.
I would use the MySQL connector directly, but I need to use ODBC to
abstract the database connection. MySQL is not the only database we
connect to. The question is, is it possible to go MySQL -> ODBC -> JDBC
-> Struts 2? It was possible under Struts 1.1 on WinXP, and we are
attempting to migrate to Struts 2 (or trying to) on Win7 64-bit.
TG
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Manos Batsis <ma...@geekologue.com>.
Todd Grigsby wrote:
>
> Fantastic! The error that I'm getting is,
> "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory ([Microsoft][ODBC Driver Manager] The
> specified DSN contains an architecture mismatch between the Driver and
> Application." Ever seen that?
My guess is you are using a microsoft ODBC to JDBC driver or something?
Just use the JDBC drivers for MySQL. You can download those and get
docos from MySQL's website.
hth,
Manos
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: MySQL + JDBC
Posted by Todd Grigsby <st...@tgrigsby.com>.
Fantastic! The error that I'm getting is,
"org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory ([Microsoft][ODBC Driver Manager] The
specified DSN contains an architecture mismatch between the Driver and
Application." Ever seen that?
TG
Neil Aggarwal wrote:
>> Let me simplify the question: Has anyone out there managed to
>> create a
>> working connection to the latest version of MySQL 64-bit via
>> JDBC from
>> Struts 2?
>>
>
> I am sure many people have. I run 64 bit servers with MySQL
> and Struts 2.
>
> What are you seeing?
>
> Neil
>
> --
> Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
> Host your Struts app on a CentOS VPS for only $25/month!
> Unmetered bandwidth = no overage charges, 7 day free trial
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
>
RE: MySQL + JDBC
Posted by Neil Aggarwal <ne...@JAMMConsulting.com>.
> Let me simplify the question: Has anyone out there managed to
> create a
> working connection to the latest version of MySQL 64-bit via
> JDBC from
> Struts 2?
I am sure many people have. I run 64 bit servers with MySQL
and Struts 2.
What are you seeing?
Neil
--
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
Host your Struts app on a CentOS VPS for only $25/month!
Unmetered bandwidth = no overage charges, 7 day free trial
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org