This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallAnywhere
- :
- InstallAnywhere Forum
- :
- Re: IA with SQL
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 13, 2009
11:37 PM
IA with SQL
Hi everyone,
I am using IA with MySQL inbuilt feature.
In that there's field for port number.
I want to ask it to the user so i want to put a variable there, like $PORT_NO$
.But the problem is that it doesnt take any non numeric value.
So i am unable to enter value $PORT_NO$ into it.
Any help will be apreciated.
Thanks.
I am using IA with MySQL inbuilt feature.
In that there's field for port number.
I want to ask it to the user so i want to put a variable there, like $PORT_NO$
.But the problem is that it doesnt take any non numeric value.
So i am unable to enter value $PORT_NO$ into it.
Any help will be apreciated.
Thanks.
(6) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 21, 2009
05:25 PM
raja_tiwari wrote:
Hi everyone,
I am using IA with MySQL inbuilt feature.
In that there's field for port number.
I want to ask it to the user so i want to put a variable there, like $PORT_NO$
.But the problem is that it doesnt take any non numeric value.
So i am unable to enter value $PORT_NO$ into it.
Any help will be apreciated.
Thanks.
I had a similar issue that I can't use variable for ports. I ended up using the generic JDBC connect with specific jdbc connection url/strings. All you have to do is substitue the values with variables in the jdbc url string. I belive the one for mySql is jdbc:mysql://localhost:3306/mysqldb
e.g. for oracle
jdbc:oracle:thin:@$DB_ORACLE_HOSTNAME$:$DB_ORACLE_PORT$:$DB_ORACLE_DBNAME$
make sure you check the "custom driver setting", enter the driver class info and include the jar files.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 27, 2009
05:12 AM
The problem is that we can not ship the oracle jars.
So we can not specify oracle jar in custom driver settings option... bcoz then IA bundles that jar with the installer.
we are asking the user to download the oracle jar and give the path location to that oracle jar.
how can we use this jar (downloaded by user) to be used in the custom driver setting ..?
bcoz custom driver settings does not allow to give some path it requires that jar to be on your machine.
any help on this?
So we can not specify oracle jar in custom driver settings option... bcoz then IA bundles that jar with the installer.
we are asking the user to download the oracle jar and give the path location to that oracle jar.
how can we use this jar (downloaded by user) to be used in the custom driver setting ..?
bcoz custom driver settings does not allow to give some path it requires that jar to be on your machine.
any help on this?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 12, 2009
10:12 AM
raja_tiwari wrote:
Hi everyone,
I am using IA with MySQL inbuilt feature.
In that there's field for port number.
I want to ask it to the user so i want to put a variable there, like $PORT_NO$
.But the problem is that it doesnt take any non numeric value.
So i am unable to enter value $PORT_NO$ into it.
Any help will be apreciated.
Thanks.
Hello Raja,
This issue has been reported by other customers as well and the fix will be available in the InstallAnywhere 2009 Service Pack 1, which will be released some time in Q2.
Regards,
Quenio
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 06, 2009
01:02 PM
qqqqqq wrote:
The problem is that we can not ship the oracle jars.
So we can not specify oracle jar in custom driver settings option... bcoz then IA bundles that jar with the installer.
we are asking the user to download the oracle jar and give the path location to that oracle jar.
how can we use this jar (downloaded by user) to be used in the custom driver setting ..?
bcoz custom driver settings does not allow to give some path it requires that jar to be on your machine.
any help on this?
Any idea whether this issue can be fixed? I can't ship with the MySQL jars and I want it to use the one the user specified, but I can't seem to figure out how.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 07, 2009
02:46 AM
AFAIK the IA 2009 SP 1 has already been released.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 07, 2009
08:13 AM
I'm using IA 2009 SP 1. It doesn't fix the problem I've described where you want to use the MySQL JDBC driver from the user (instead of one packaged with your installer).
![](/skins/images/CC38E504FC9E1309DC48ACFEB4925670/responsive_peak/images/icon_anonymous_message.png)