|
This is my first Java database application so I'm sure I'm missing something. This is the code I have...
import java.sql.*;
public class ClsConn {
private Connection conn;
public Connection openConn() {
try {
System.out.println("Trying the connection now...");
Class.forName("net.sourceforge.jtds.jdbc.Driver");
conn = java.sql.DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433;databaseName=Intranet;user=sa;password=passwrd");
System.out.println("DSN Connection ok.");
} catch (Exception e) {
System.out.println("DSN Exception: " + e.getMessage());
e.printStackTrace();
}
return conn;
}
}
This was originally using a DSN, but that didn't seem to work (I was getting some interesting behavior) so I've gone to what you see there. I'm getting this error message: Cannot open database "Intranet" requested by the login. The login failed.
For reference on the same server for my asp pages I have the following which is working:
Public Function OpenConnection() As Boolean
Dim connString As String
cnn = New SqlConnection
connString = "server=localhost; uid=sa; pwd=password; database=intranet"
Try
cnn.ConnectionString = connString
cnn.Open()
Return True
Catch ex As SqlException
GlobalClasses.Client_Alert(ex.Message)
Return False
End Try
End Function
I have opened up 1433 on the server so I have no idea what's going on... Any ideas would be greatly appreciated...
--Update 1--
For "fun" I just changed the Database to "Master" and the gosh darn thing "works"... well my query fails because the table it's looking for isn't in Master but the connection is working. I really need to start drinking or something. So it appears that everything is working for for some reason I can't see the database???
--Update 2--
Ok so I change my query figured that would be a good idea right? Nah... So I put in "use Intranet SELECT...." and get "Exception: Database 'Intranet' does not exist. Make sure that the name is entered correctly.". So I did what any good frustrated developer would do and opened up the mgmt studio for SQL Server and went to master and ran the same exact query with the "use..." (yes I cut and pasted it in just to be 100% sure) and imagine that it works. Yet my Java application is still saying it doesn't exist.
I am trying to figure this out not just waiting for an answer... 
--Update 3--
Connection string is now:
conn = java.sql.DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/master;user=sa;password=passwrd");
modified 7-Mar-13 10:46am.
|
|
|
|
|
Ok, combo of hatred of M$ and Java here.... apparently when I installed Visual Studio Web edition or IIS it put a copy of SQL Server 2008 Express and Java was nice enough to grab that one vs the 2012 which Visual studio was... Stopped the service for 2008 and now it's working... I'm going to go grab a drink now.
|
|
|
|
|
Hi I have one production issue related to database connection.
Earlier it was a single threaded now other team migrated to Multithreaded application. After migration we have some production related to database connectivity when we perform more operations.
Please find the below logs and hibernate config xml file.
Could some one help me to fix this issue.
Error logs :----
2013-03-01 10:23:53,803 (pool-2-thread-5) [DEBUG] CacheTranscodeManagerImpl - files copied from /opt/transcode/transcode/cache/SN-API-COMCAST_NATIONAL-HD-NC/3DBE3E900937F028BE397C9158CF8510 to /opt/transcode/transcode/output/559311
2013-03-01 10:23:54,449 (pool-2-thread-5) [WARN ] JDBCExceptionReporter - SQL Error: 0, SQLState: null
2013-03-01 10:23:54,449 (pool-2-thread-5) [ERROR] JDBCExceptionReporter - Connection is closed.
2013-03-01 10:23:54,449 (pool-2-thread-5) [ERROR] AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not update: [com.scrippsnetworks.transcode.model.TranscodeCache#248019]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateTemplate$27.doInHibernate(HibernateTemplate.java:801)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:799)
at com.scrippsnetworks.transcode.dao.impl.TranscodeCacheDaoImpl.saveTranscodeCache(TranscodeCacheDaoImpl.java:36)
at com.scrippsnetworks.transcode.service.impl.TranscodeCacheManagerImpl.saveTranscodeCache(TranscodeCacheManagerImpl.java:22)
at com.scrippsnetworks.transcode.service.impl.CacheTranscodeManagerImpl.getTranscodeResult(CacheTranscodeManagerImpl.java:201)
at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:203)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:162)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)
at $Proxy23.getTranscodeResult(Unknown Source)
at com.scrippsnetworks.transcode.service.CacheRunner.run(CacheRunner.java:42)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Connection is closed.
at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:291)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:183)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2354)
... 29 more
2013-03-01 10:23:54,452 (pool-2-thread-5) [ERROR] JDBCTransaction - Could not toggle autocommit
java.sql.SQLException: Connection is closed.
at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:291)
at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardC
Hibernate config xml :-
<bean id="dataSourceTS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="url"><value>${jdbc.url}</value></property>
<property name="username"><value>${jdbc.username}</value></property>
<property name="password"><value>${jdbc.password}</value></property>
<property name="driverClassName"><value>${jdbc.driver}</value></property>
<property name="maxActive" value="100"/>
<property name="maxIdle" value="30"/>
<property name="maxWait" value="1000"/>
<property name="defaultAutoCommit" value="true"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="60"/>
</bean>
thanks in advance.
Thanks
Ravindra Reddy
|
|
|
|
|
Hello,
try specifying the instance parameter in connection string. Following text is extracted from the JTDS FAQ. SQL Server can run multiple so-called "named instances" (i.e. different server instances, running on different TCP ports) on the same machine. When using Microsoft tools, selecting one of these instances is made by using "<host_name>\<instance_name>" instead of the usual "<host_name>". With jTDS you will have to split the two and use the instance name as a property.
Regards,
Prasad P. Khandekar
Knowledge exists, man only discovers it.
|
|
|
|
|
I have problem for creating invoice
like OpenERP invoice
any one can help me?
|
|
|
|
|
This is not a well framed question! We cannot work out what you are trying to do/ask from the post.
You need to elaborate and be specific on what are you trying to do and where are you stuck. Use the "Edit" link to edit your question and provide better information.
|
|
|
|
|
hi friends, please assist me with a game that has 5 marbles(balls)and marbles are hit with a paddle and roll on the panel and drop to a circular hole.......in java
thanks
|
|
|
|
|
What help exactly? If you are expecting someone to write this for you then you will be disappointed. If you are looking for useful samples then go to the CodeProject Articles section[^].
Use the best guess
|
|
|
|
|
 Hello,
I have a project that must use the artificial immune system as a method of classification.
I've asked my questions on other forums, but no large numbers of people who have used this method.
So please, someone he already used the AIS?
I depend on your support please for my project entitled:
"Application of the immune system for recognizing artificial
forms; the Arabic Script"
|
|
|
|
|
|
Hello,
I have a project that must use the artificial immune system as a method of classification.
I've asked my questions on other forums, but no large numbers of people who have used this method.
So please, someone he already used the AIS?
I depend on your support please for my project entitled:
"Application of the immune system for recognizing artificial
forms; the Arabic Script"
|
|
|
|
|
see my reply here ^
Q. Hey man! have you sorted out the finite soup machine?
A. Why yes, it's celery or tomato.
modified 6-Mar-13 10:59am.
|
|
|
|
|
Bonjour,
j'ai un projet qui doit obligatoirement utiliser le système immunitaire artificiel comme méthode de classification.
j'ai déjà posé mes questions sur d'autres forums, mais il n'y a pas grand nombres de personnes qui ont utilisé ce procédé.
Donc svp, quelqu'un à t-il déjà utilisé l'AIS ?
je depend de vos aides s'il vous plaît pour réaliser mon projet intitulé:
" Application du système immunitaire artificiel pour la reconnaissance de
formes'' l’Écriture arabe "
et merci
|
|
|
|
|
This is an English speaking website/forum. could you please translate that to English so that every one could understand and answer to your query.
|
|
|
|
|
لحن الأماني wrote: Hello,
I have a project that must use the artificial immune system as a method of classification.
I've asked my questions on other forums, but no large numbers of people who have used this method.
So please, someone he already used the AIS?
I depend on your support please for my project entitled:
"Application of the immune system for recognizing artificial
forms; the Arabic Script"
I'm not sure what you are asking here, but if you want someone to provide you with a ready made answer then you will be disappointed.
Je ne suis pas sûr de ce que vous demandez ici, mais si vous voulez quelqu'un pour vous donner une réponse toute faite, alors vous allez être déçu.
Use the best guess
|
|
|
|
|
A bit of googling around came up with the following research paper..
pdf
a book: cleveralgorithms.com/nature-inspired/immune/
Similar *research* (and publications) on artificial life can be found at santafe.edu
Q. Hey man! have you sorted out the finite soup machine?
A. Why yes, it's celery or tomato.
|
|
|
|
|
Interesting, but I didn't ask the question.
Use the best guess
|
|
|
|
|
Oops. My mistake. 
yikes he has multiple posts.
Q. Hey man! have you sorted out the finite soup machine?
A. Why yes, it's celery or tomato.
|
|
|
|
|
how we stored the data into collection class in java
|
|
|
|
|
|
Hey guys & gals.
I'm just asking a quick question about my end of year college project.
I've written an Android application which scans student ID's, gets the information from the barcode, sends that to a server which shows on screen via WiFi.
Now currently I have it set so when it receives the info it saves to a txt file.
I allready have an excel file with details in it e.g Student Number, days present, Submission.
Is it possible for me to use a button press on the Server GUI that will take the string e.g "ABC12345" from the txt file and run a check against "ABC12345" in the Excel file containing the students info? which will then do checks using "fuzzy" logic, e.g if they missed 4 days out of 20 they're OK and if they miss 15 out of 20 they're in trouble?
If it is possible to do, could you give me some guidance on how to go about checking the txt file string against the Excel and any tutorials I can read up on? 
Thanks in advance!
Mark.
|
|
|
|
|
There is a Java library (see here[^]) which allows you to read Excel files.
Use the best guess
|
|
|
|
|
Will give it a look and get back to you, cheers! 
|
|
|
|
|
hi every one
I need some help with my android app
I have been searching for tutorials to fined the nearest places
at my country and details about them ..
but I was surprised I haven't getting any useful results
would some one please help : (
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
